Release 10.1A: OpenEdge Data Management:
SQL Reference

SIGN

Returns 1 if expression is positive, -1 if expression is negative, or zero if expression is zero.

Syntax

SIGN ( expression )

Example

This example illustrates the SIGN function:

SELECT SIGN(-14) 'Sign' FROM MYMATH;

Note

expression must evaluate to a NUMERIC data type.

Compatibility

ODBC compatible